﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Settings;
using Utils;
using System.Data.SqlClient;

namespace PanasonicWarranty.Business
{
    public partial class SmsStatistic : BaseClass
    {
        public static DataTable StatisticSmsWarranty(DateTime fromTime, DateTime toTime)
        {
            return ExecuteReader("usp_StatisticSmsWarranty", CommandType.StoredProcedure,
                                    new SqlParameter("@StartDate", fromTime), new SqlParameter("@EndDate", toTime));
        }

        public static DataTable StatisticMOMT(DateTime fromTime, DateTime toTime)
        {
            return ExecuteReader("usp_StatisticMOMT", CommandType.StoredProcedure,
                new SqlParameter("@StartDate", fromTime), new SqlParameter("@EndDate", toTime));
        }
    }
}
